home *** CD-ROM | disk | FTP | other *** search
- ================================================================
- PLAN.DOC
- ================================================================
-
- This document deals with conversion of features from PlanPerfect
- 3.0 and 5.x to WordPerfect 6.0. Currently, converting tables
- from WordPerfect 6.0 to PlanPerfect is not supported.
-
-
- PLANPERFECT 3.0 and 5.x WORDPERFECT 6.0
- ======================= ===============
- Calculations
-
- Iteration Not converted
-
- Iteration Formula Not converted
-
- Mode (Automatic, Manual) Not converted
-
- Order Not converted
-
- Round Value Not converted
-
- Compose Characters All extended characters are
- converted
-
- Edit Window (Text) Converted to individual cells,
- with each line of text in a
- separate cell
-
- Font
-
- Select for Cell or Block Converted to font/size codes
- within the table cell
-
- Select for Column Converted to font/size codes
- within table column
-
- Select for Worksheet Converted to a font/size code
- at the beginning of the table
-
- Format
-
- Alignment
-
- Cell
-
- Center, Numbers Converted to Center
- or Text Justification assigned to
- table cell
-
- Left, Numbers Converted to Left
- or Text Justification assigned to
- table cell
-
- Right, Numbers Converted to Right
- or Text Justification assigned to
- table cell
-
- Column
-
- Center, Numbers Converted to Center
- or Text Justification assigned to
- table column
-
- Left, Numbers Converted to Left
- or Text Justification assigned to
- table column
-
- Right, Numbers Converted to Right
- or Text Justification assigned to
- table column
-
- Worksheet
-
- Center, Numbers Converted to Center
- or Text Justification assigned to
- entire table
-
- Left, Numbers Converted to Left
- or Text Justification assigned to
- entire table
-
- Right, Numbers Converted to Right
- or Text Justification assigned to
- entire table
-
- Attributes
-
- Alternate Font, Converted to Italics attribute
- Select (PlanPerfect 3.0 files only)
-
- Bold Converted to Bold attribute
-
- Cell or Block Converted to attribute(s)
- assigned to the current table
- cell or block
-
- Column Converted to attribute(s)
- assigned to the current table
- column
-
- Double-Underline Converted to Double-Underline
- attribute
-
- Font Converted to font/size codes
- within table cell
-
- Hide Converted to hidden text
-
- Italics Converted to Italics attribute
-
- Underline Converted to Underline
- attribute
-
- Worksheet Converted to attributes
- assigned to the entire table
-
- Zero Suppress (Hide If a cell value is zero, it is
- If Zero) converted to hidden text.
- Otherwise, no change.
-
- Column
-
- Column Width Converted to approximate inch
- equivalent
-
- Suppress Not converted
-
- Edit
-
- Appearance Converted to equivalent
- appearance attribute
-
- Size Converted to equivalent size
- attribute
-
- Format Page
-
- Headers/Footers
-
- Text Converted to header/footer
- text, except if imported into
- existing WordPerfect 6.0
- document.
-
- Alignment (|) Use of | character to create
- alignment is converted to
- appropriate alignment codes
- within header or footer.
-
- Cell Reference Not converted
-
- ^B (Pg. Number) Converted to Page Numbering
- code within header or footer
-
- ^D (Date) Converted to Date code within
- header or footer
-
- Line Height Converted to line height code
-
- Margins
-
- Bottom Converted to Bottom Margin
- Code
-
- Left Converted to Left Margin code
-
- Right Converted to Right Margin code
-
- Top Converted to Top Margin code
-
- Number Pages Converted to Page Numbering
- code
-
- Page Number Position Converted to Page Numbering
- code
-
- Paper/Size Type Converted to Paper Size/Type
- code
-
- Print
-
- Borders Y/N Not converted
-
- Print Titles Not converted
- Y/N
-
- Printer Functions
-
- Kerning Kerning
-
- Type
-
- Accounting Converted to Accounting number
- type format
-
- Comma Converted to Comma number type
- format
-
- Currency Converted to Currency number
- type format
-
- Date Converted to Date number type
- format
-
- Decimal Aligned Converted to the General
- Numbers number type format, Left
- justification, and Decimal
- Alignment position at n
- digits.
-
- Fixed Converted to the Fixed number
- type format
-
- General Converted to the General
- number type format
-
- Integer Converted to the Integer
- number type format
-
- Other
-
- Commas Not converted
-
- Decimal Not converted
- Precision
-
- Gutter Space Not converted
-
- Negative Number Not converted
- options
-
- Parentheses Not converted
-
- Round for Calc. Not converted
-
- Spec. Not converted
- Characters
-
- Percent Converted to the Percent
- number type format
-
- Scientific Converted to the Scientific
- number type format
-
- Text Format Converted to the Text type
- format
-
- Date/Time Format Converted to the Date/Time
- type format
-
- Worksheet
-
- Borders, Display Not converted
-
- Display
-
- Formulas Not converted
-
- Spec. Char Not converted
- Argument
- Separator
-
- Spec. Char. Converted to one of the
- Currency currency formats listed in the
- Symbol(S) .LRS file
-
- Spec. Char. Converted to Decimal Align
- Decimal Align Character code
-
- Spec. Char. Converted to Thousands
- Thousands Separator code
- Separator
-
- Sort Language Converted to Language code
-
- Summary Converted to Document Summary
-
- Width Converted to table Column
- Width setting
-
- Formula
-
- Absolute Converted to absolute cell
- reference (entire cell
- reference enclosed in square
- brackets)
-
- Logical Operators >, <, Converted to equivalent
- =, <>, >=, <= logical operators
-
- Mixed Converted to mixed cell
- reference (square brackets may
- surround either column
- reference letter or row
- reference number)
-
- Operators +, -, /, *, ^, Converted to equivalent
- % arithmetic operators
-
- Relative Converted to cell reference
-
- Functions
-
- Arithmetic Functions
-
- ABS() ABS()
-
- ACOS() ACOS()
-
- ASIN() ASIN()
-
- ATAN() ATAN()
-
- ATAN2() ATAN2()
-
- AVE() AVE()
-
- COS() COS()
-
- DEGREES() DEGREES()
-
- EXP() EXP()
-
- FACT() FACT()
-
- INT() INT()
-
- LN() LN()
-
- LOG() LOG()
-
- MAX() MAX()
-
- MIN() MIN()
-
- MINUS() MINUS()
-
- MOD() MOD()
-
- PI() PI()
-
- POWER() POWER()
-
- PRODUCT() PRODUCT()
-
- QUOTIENT() QUOTIENT()
-
- RADIANS() RADIANS()
-
- RANDOM() RANDOM()
-
- ROUND() ROUND()
-
- SIN() SIN()
-
- SQRT() SQRT()
-
- STDEV() STDEV()
-
- STDEVP() STDEVP()
-
- SUBTRACT() SUBTRACT()
-
- SUM() SUM()
-
- TAN() TAN()
-
- VAR() VAR()
-
- VARP() VARP()
-
- Date & Time Functions
-
- DATE() DATE()
-
- DATETEXT() DATETEXT()
-
- DATEVALUE() DATEVALUE()
-
- DAY() DAY()
-
- HMS() HMS()
-
- HOUR() HOUR()
-
- MDY() MDY()
-
- MINUTE() MINUTE()
-
- MONTH() MONTH()
-
- SECOND() SECOND()
-
- TIME() TIME()
-
- TIMETEXT() TIMETEXT()
-
- TIMEVALUE() TIMEVALUE()
-
- YEAR() YEAR()
-
- Financial Functions
-
- DDB() DDB()
-
- FV() FV()
-
- IRR() IRR()
-
- NPV() NPV()
-
- PMT() PMT()
-
- PV() PV()
-
- RATE() RATE()
-
- SLN() SLN()
-
- SYD() SYD()
-
- TERM() TERM()
-
- Logical Functions
-
- AND() AND()
-
- FALSE() FALSE()
-
- FOREACH() Not converted
-
- IF() IF()
-
- ISERR() ISERR()
-
- ISERR2() ISERR2()
-
- ISNA() ISNA()
-
- ISTEXT() ISTEXT()
-
- ISVALUE() ISVALUE()
-
- NA() NA()
-
- NOT() NOT()
-
- OR() OR()
-
- SIGN() SIGN()
-
- TRUE() TRUE()
-
- Special Functions
-
- BLOCK() BLOCK()
-
- CELL() CELL()
-
- CHOOSE() CHOOSE()
-
- COL() COL()
-
- COUNT() COUNT()
-
- CURSOR() Not converted
-
- INDEX() INDEX()
-
- ITERATION() Not converted
-
- LOOKUP() LOOKUP()
-
- LOOKUP2() LOOKUP2()
-
- MATCH() MATCH()
-
- MATCH2() MATCH2()
-
- ROW() ROW()
-
- STATUS() Not converted
-
- Text Functions
-
- CHAR() CHAR()
-
- CODE() CODE()
-
- CONCAT() CONCAT()
-
- CURRENCY() CURRENCY()
-
- FIND() FIND()
-
- LEFT() LEFT()
-
- LENGTH() LENGTH()
-
- LOWER() LOWER()
-
- MID() MID()
-
- PROPER() PROPER()
-
- REPEAT() REPEAT()
-
- REPLACE() REPLACE()
-
- RIGHT() RIGHT()
-
- TEXT() TEXT()
-
- TRIM() TRIM()
-
- UPPER() UPPER()
-
- VALUE() VALUE()
-
- Graph Graphs are not supported in
- WordPerfect 6.0
-
- Help, Cell Message Not converted
-
- Insert
-
- Printer Command Not converted
-
- Lock/Unlock
-
- Cell Converted to locked cell
-
- Column Converted to locked column
-
- Worksheet Converted to locked except
- blank cells, which are
- converted to Unlocked cells
-
- Macro
-
- Cell Macro Cell macros are not supported
- in WordPerfect 6.0
-
- Model Mode On/Off Spreadsheet Model Mode is not
- supported in WordPerfect 6.0
-
- Named
-
- Blocks Converted to named table block
-
- Cell Converted to named table
- cell(s)
-
- Columns Converted to named table
- column(s)
-
- Rows Converted to named table
- column(s)
-
- Page Break (\\Page) Converted to a soft page break
- within the table
-
- Password Add/Delete Converted to document password
-
- Screen
-
- Titles
-
- Across Converted to a Header Row
-
- Lock Y/N Converted to Unlock
-
-
-
- Importing spreadsheets up to 64 columns is supported. If you try
- to import a spreadsheet with more than 64 columns, all columns
- after the 64th column are truncated.
-
- Importing a spreadsheet into a WordPerfect 6.0 document changes
- the Table Line defaults for all following tables to "None."
- Tables following the imported spreadsheet will need to be edited
- and changed to restore the table lines and borders.
-
- A period (.) in a table name is converted to an underscore (_).
-
- Reference in a Header or Footer to a cell such as <A8> converts
- to the actual text <A8> instead of the contents of cell A8.
-
- Functions not supported in WordPerfect 6.0 tables will convert as
- the calculated value of that function.
-
- Hidden columns will convert to a column width of .001. Changing
- the column width in WordPerfect 6.0 will expand hidden columns
- and turning on the 'Show All Hidden Text' option will allow the
- data in each table cell to be viewed.
-
- Blank cells in a spreadsheet with global protection on will
- convert unlocked.